<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
	<title>CREATE COURSE HANDLER</title>
</head>

<body>
	<?php
		$username = $_COOKIE['studialusername'];
		$password = $_COOKIE['studialuserpwd'];
		$userid = $_COOKIE['studialuserid'];
		$courseName = $_POST['courseName'];
		$description = $_POST['description'];
		$period = $_POST['period'];
		$courseName = $_POST['courseName'];
			
		@ $db = mysql_pconnect("localhost","root","");
			
		if(!$db)
		{
			echo "<h2>Database does not exist!</h2>";
			exit;
		}
		
		$now = getdate();
		
		$query = "INSERT INTO `Studial`.`courses` (`university_id`, `faculty_id`, `administrator_id`, `name`, `description`, `startdate`, `period`) VALUES ('".$UniversityID."', '".$FacultyID."', '".$userid."', '".$courseName."', '".$description."', '".$now."', '".$period."')";
		mysql_query($query);
		
		$selectCourse = "SELECT * FROM `courses' WHERE startdate = ".$now."'";
		$resultCourse = mysql_query($selectCourse);
		$rowCourse = mysql_fetch_array($resultCourse);
		
		header("location: ../studial/courses/homeboard.php?id=".stripslashes($rowCourse['id']));
	?>
</body>
</html>